from flask_sqlalchemy import SQLAlchemy
db = SQLAlchemy()

class StuInfo(db.Model):
    sid = db.Column(db.String, primary_key=True)
    name = db.Column(db.String(80), unique=True)
    sex = db.Column(db.Integer,unique=True)
    class_name = db.Column(db.String(80), unique=True)
    phone = db.Column(db.String(11), unique=True)
    grade = db.Column(db.Integer, unique=True)
    major_name = db.Column(db.String(100), unique=True)
    college_name = db.Column(db.String(100), unique=True)
    email = db.Column(db.String(120), unique=True)
    password = db.Column(db.String(120), unique=True)
    desc = db.Column(db.String(255),unique=True)